-- --------------------------------------------------------

--
--   `cms_board_items`
--

CREATE TABLE IF NOT EXISTS `cms_board_items` (
  `id` int(11) NOT NULL auto_increment,
  `category_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `obtype` varchar(50) NOT NULL,
  `title` varchar(250) NOT NULL,
  `content` text NOT NULL,
  `city` varchar(100) NOT NULL,
  `pubdate` datetime default NULL,
  `pubdays` int(11) NOT NULL,
  `published` int(11) NOT NULL,
  `file` varchar(250) NOT NULL,
  `hits` int(11) NOT NULL,
  `is_vip` tinyint(4) NOT NULL default '0',
  `vipdate` datetime NOT NULL,
  `metakeys` varchar(250) default NULL,
  `metadesc` varchar(250) default NULL,
  `boardtitle` varchar(250) default NULL,
  PRIMARY KEY  (`id`),
  KEY `category_id` (`category_id`),
  KEY `user_id` (`user_id`),
  KEY `obtype` (`obtype`),
  KEY `city` (`city`),
  FULLTEXT KEY `content` (`content`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=7 ;

--
--    `cms_board_items`
--

INSERT INTO `cms_board_items` (`id`, `category_id`, `user_id`, `obtype`, `title`, `content`, `city`, `pubdate`, `pubdays`, `published`, `file`, `hits`, `is_vip`, `vipdate`, `metakeys`, `metadesc`, `boardtitle`) VALUES
(4, 10, 1, '', '  ', '     .', '', '2009-10-26 14:11:18', 10, 1, '550de8a5de9b5301133a815de31be00d.jpg', 12, 0, '0000-00-00 00:00:00', '222', '333', '111'),
(5, 9, 1, '', ' -2107  Nissan Skyline GTR', '    .', '', '2009-10-26 14:14:24', 10, 1, '931f90c50adcea1ff18177bc22d4ceac.jpg', 37, 0, '0000-00-00 00:00:00', NULL, NULL, NULL),
(6, 8, 2, '', ' 2-  ', '  2-3 ', '', '2010-10-28 15:57:22', 10, 1, '80204e6bad519060bca9d456949158dc.jpg', 46, 0, '0000-00-00 00:00:00', '   ', '  ', ' ');
